Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MerchandiseHierarchyGroupID (PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | |
ItemSellingRuleID (FK) | A unique system assigned identifier for the ItemSellingPrices. | ID_RU_ITM_SL | Identity | integer | ItemSellingRule(RU_ITM_SL) |
Name | The business name for the merchandise structure. | NM_MRHRC_GP | DescriptionShort | varchar(255) | |
Description | A brief text description of the merchandise structure. | DE_MRHRC_GP | DescriptionShort | varchar(255) | |
WeatherConditionTypeCode (FK) | Code used to identify a collection of weather characteristics that are important to a retailer in tracking sales and operations. | CD_WTHR_CN_TYP | Code | varchar(20) | WeatherConditionType(CO_WTHR_CN_TYP) |
ClimateTypeCode (FK) | Climate Group: A Tropical Humid Climates Climate Group: B Dry Climates Climate Group: C Mild Midlatitude Climates Climate Group: D Severe Midlatitude Climates Climate Group: E Polar Climates Climate Group: H Highland Climates Letter Code: Af Climate Type: Tropical Wet General Characteristics: Rain Throughout Year Letter Code: Aw Climate Type: Tropical Savanna General Characteristics: Winter (Low-Sun) Dry Season Letter Code: Am Climate Type: Tropical Monsoon General Characteristics: Short Dry Season; Heavy Rains in Other Months Letter Code: BWh Climate Type: Subtropical Desert General Characteristics: Low-Latitude (Hot) Desert Letter Code: BSh Climate Type: Subtropical Steppe General Characteristics: Low-Latitude (Hot) Semiarid Letter Code: BWk Climate Type: Midlatitude Desert General Characteristics: Midlatitude (Cold) Desert Letter Code: BSk Climate Type: Midlatitude Steppe General Characteristics: Midlatitude (Cold) Semiarid Letter Code: Csa Climate Type: Mediterranean General Characteristics: Dry, Hot Summer Letter Code: Csb Climate Type: Mediterranean General Characteristics: Dry, Warm Summer Letter Code: Cfa Climate Type: Humid Subtropical General Characteristics: No Dry Season; Hot Summer Letter Code: Cwa Climate Type: Humid Subtropical General Characteristics: Dry Winter; Hot Summer Letter Code: Cfb Climate Type: Marine West Coast General Characteristics: No Dry Season; Warm Summer Letter Code: Cfc Climate Type: Marine West Coast General Characteristics: No Dry Season; Cool Summer Letter Code: Dfa Climate Type: Humid Continental General Characteristics: Severe Winter; No Dry Season; Hot Summer Letter Code: Dfb Climate Type: Humid Continental General Characteristics: Severe Winter; No Dry Season; Warm Summer Letter Code: Dwa Climate Type: Humid Continental General Characteristics: Severe Winter; Dry Winter; Hot Summer Letter Code: Dwb Climate Type: Humid Continental General Characteristics: Severe Winter; Dry Winter; Warm Summer Letter Code: Dfc Climate Type: Subarctic General Characteristics: Severe Winter; No Dry Season; Cool Summer Letter Code: Dfd Climate Type: Subarctic General Characteristics: Very Cold Winter; No Dry Season Letter Code: Dwc Climate Type: Subarctic General Characteristics: Dry Winter; Cool Summer Letter Code: Dwd Climate Type: Subarctic General Characteristics: Dry Winter; Very Cold Winter Letter Code: ET Climate Type: Tundra General Characteristics: Polar Tundra With No True Summer Letter Code: EF Climate Type: Tundra General Characteristics: Polar Ice Cap Letter Code: H General Characteristics: High Elevation Climates Sub-Symbol: f Wet, Rainy, or No Dry Season Sub-Symbol: w Dry Winter Sub-Symbol: m Monsoon, heavy rains Sub-Symbol: W (Only for B climates) Desert Sub-Symbol: S (Only for B climates) Semiarid Sub-Symbol: h (Only for B climates) Hot Sub-Symbol: k (Only for B climates) Cold Sub-Symbol: s (Only for C-Mediterranian climates) Dry Summer Sub-Symbol: a Hot Summer Sub-Symbol: b Warm Summer Sub-Symbol: c Cool Summer Sub-Symbol: d (Only for D-Subarctic climates) Very Cold Winter Sub-Symbol: T (Only for E-Tundra climates) Polar Tundra With No True Summer Sub-Symbol: F (Only for E-Ice Cap climates) Polar Ice Cap | CD_CLMT_TYP | Code | varchar(20) | ClimateType(LU_CLMT_TYP) |
ActivityInterestCode (FK) | A lookup value that designates a valid activity or interest code used to segment customers. The code list must be defined by the retailer. | CD_ACTV_INTRST | Code | varchar(20) | ActivityInterest(CO_ACTV_INTRST) |
OccasionName (FK) | The name ofr the Holiday instance | NM_HLDY | Name | varchar(40) | Holiday(CO_HLDY) |